<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Usuarios</title>
    <link href="estilos.css" rel="stylesheet" type="text/css" />
	</head>
	<body>
		<label class="Titulo">Users</label>
	    	<table border="1" cellspacing=1 cellpadding=2 style="font-size: 8pt"><tr>
	        <td><font face="verdana"><b>Email</b></font></td>
	        <td><font face="verdana"><b>Administrator</b></font></td></tr>
	        <?php  
				include "conexion.php";
	
	  			$query = "SELECT * from user " ;
	  			$result = mysql_query($query);
	  			while($row = mysql_fetch_array($result))
	 			 {
	    			echo "<tr><td width=\"25%\"><font face=\"verdana\">" . 
		   				 $row["user_mail"] . "</font></td>";
	    			if ($row["administrator"]=='1'){ echo "<td> yes </td>";}
	    			else{echo "<td> no </td>";}
	  			} 
	      		"</b></font></td></tr>";
	  
	 			 mysql_free_result($result);
	  			 include "cerrar_conexion.php";
			?>
			</table>
			<p>&nbsp;</p>
			<form name="formulario1" action='addadministrator1.php' method="post">
				<input type="submit" value="Add administrator" class='boton'>
			</form>
			<form name="formulario2" action='deleteadministrator1.php' method="post">
				<input type="submit" value="Delete administrator" class='boton'>
			</form>

	</body>
</html>